* Apply to: expert_1.xlsx
* Description:  Tabulate expert ratings of DCCC, RCCC

clear

set more off


import excel "...\1805 Roadmaps\expert_1.xlsx", sheet("Sheet1") firstrow


* Combine two ratings questions

gen rate_dccc = q4_dccc
replace rate_dccc = q6_dccc if rate_dccc==99

gen rate_rccc = q4_rccc
replace rate_rccc = q6_rccc if rate_rccc==99


* Table A7 (experts)

* Democratic County Central Committee
* 1 = Extermely liberal / Strong progressive 
* 2 = Liberal / Progressive
* 3 = Somewhat liberal / Lean progressive
* 4 = In the middle / In the middle
* 5 = Somewhat conservative / Lean moderate
* 6 = Conservative / Moderate
* 7 = Extremely conservative / Strong moderate

tab rate_dccc if rate_dccc<=7

tabstat rate_dccc if rate_dccc<=7, s(n mean sd)


* Republican County Central Committee
* 1 = Extermely liberal / Strong progressive 
* 2 = Liberal / Progressive
* 3 = Somewhat liberal / Lean progressive
* 4 = In the middle / In the middle
* 5 = Somewhat conservative / Lean moderate
* 6 = Conservative / Moderate
* 7 = Extremely conservative / Strong moderate

tab rate_rccc if rate_rccc<=7

tabstat rate_rccc if rate_rccc<=7, s(n mean sd)

ttesti 37 2.73 1.15 37 6.27 0.99

* End
